<?php

$_ads = Advertising::leftjoin('paypal_payments_ads as paypal','paypal.item_id','=','advertising.id')
->whereRaw('advertising.balance < advertising.quantity')
->where('payment_status','Completed')
->where('status','active')
	 ->orderByRaw('rand( '.time() . ' * ' . time().')')
	 ->take(1)
	 ->select('advertising.*')
	 ->get();

?>

<?php if( $_ads->count() != 0 ): ?>
	<?php foreach( $_ads as $ad ): ?>
	
	<?php 
		
	$url_ad = URL::to('click/ads/').'/'.$ad->id; 
	
	if( $ad->type == 'impressions' ){
		
		// URL TO URL
		$url_ad = $ad->ad_url; 
		
		// Insert Impressions
		Advertising::impressionsAds($ad->id);
		
	} else {
		$url_ad = URL::to('click/ads').'/'.$ad->id; 
	}
	
	
	?>
	
	<!-- Start Panel -->
	<div class="panel panel-default">
		<div class="panel-heading btn-block grid-panel-title">
			<span class="icon-bullhorn myicon-right"></span> <?php echo Lang::get('misc.advertising'); ?>

			
			<?php if( Auth::check() ): ?>
			<a href="<?php echo URL::to('ad/new'); ?>" class="link_ads_create pull-right">
				<?php echo Lang::get('misc.create_ad'); ?>

			</a>
			<?php endif; ?>
			</div>
	<div class="panel-body">
		<div class="btn-df li-group">
			<a target="_blank" href="<?php echo $url_ad; ?>">
				<img src="<?php echo URL::asset('public/ad/').'/'.$ad->ad_image; ?>" class="img-responsive btn-block" />
			</a>
			<a target="_blank" href="<?php echo $url_ad; ?>" class="btn-block links-ads"><?php echo e($ad->ad_title); ?></a>
			<p class="desc-ads">
				<?php echo e($ad->ad_desc); ?>

			</p>
		</div>
		</div><!-- Panel Body -->
	</div><!--./ Panel Default -->
	<?php endforeach; ?>

<?php else: ?> 

<!-- Start Panel -->
<div class="panel panel-default">
	<div class="panel-heading btn-block grid-panel-title">
		<span class="icon-bullhorn myicon-right"></span> <?php echo Lang::get('misc.advertising'); ?>

		
		<?php if( Auth::check() ): ?>
		<a href="<?php echo URL::to('ad/new'); ?>" class="link_ads_create pull-right">
			<?php echo Lang::get('misc.create_ad'); ?>

		</a>
		<?php endif; ?>
		</div>
<div class="panel-body">
	<div class="btn-df li-group">
		<a href="javascript:void(0);">
			<img src="<?php echo URL::asset('public/ad/ad.png'); ?>" class="img-responsive btn-block" />
		</a>
		<a href="javascript:void(0);" class="btn-block links-ads"><?php echo Lang::get('misc.advertise_here'); ?></a>
		<p class="desc-ads">
			<?php echo Lang::get('misc.description_ad'); ?>

		</p>
	</div>
	</div><!-- Panel Body -->
</div><!--./ Panel Default -->

<?php endif; ?>
